BULK INSERT State  
    FROM 'C:\Users\b-sdixit\Desktop\state.csv' 
    WITH 
    (							
		FIELDTERMINATOR = ',', 
        ROWTERMINATOR = '\n'        
    )